SELECT col7 , col2 , NTILE(3) OVER (PARTITION by col7 ORDER by col2) tile FROM "allTypsUniq.parquet"